UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rDYQc7CkYcJT2ouvPNyCBY5NYnXEb0LGDPCCS49unrg='
WHERE
key_id = 'ecacd40af0b4ad75762d1bce014aa78684f517a4fd72b566116648daaa1f12f7'
AND (
token = 'rDYQc7CkYcJT2ouvPNyCBY5NYnXEb0LGDPCCS49unrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)