UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UDcF2f6P6SIgvqAzYsE/eyo7YyufaLcjy8Hosju7aJo='
WHERE
key_id = 'bc3be2274aeb2fdb0bbff2868cdec1f21b27e86aeee61e57c5e046fbd22cab62'
AND (
token = 'UDcF2f6P6SIgvqAzYsE/eyo7YyufaLcjy8Hosju7aJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)