UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NMkkbomy1FKRV1ZHVkjKM/quek1V91ce+odRbN+iDSY='
WHERE
key_id = '1f015415f8d9e58377d98bd9b4e20e6c0ac35c0b81f5ad97ccee59f855b9a394'
AND (
token = 'NMkkbomy1FKRV1ZHVkjKM/quek1V91ce+odRbN+iDSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)