UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JxcSXvY9mjiZMdO8X/WvEgvpgWZUO2taEbEKXdP/aSQ='
WHERE
key_id = '6ca607459f60674c28a076134bc8a095bac5674c77abf4f2ee1ca317876eeb9e'
AND (
token = 'JxcSXvY9mjiZMdO8X/WvEgvpgWZUO2taEbEKXdP/aSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)