UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NfuQbY8anY8ZFD+zHnABv7HqVS73aqFr6SOrCqgcYno='
WHERE
key_id = '227585ef5347e4c683d4ad9aa63fd8179565dcd9e3a1353fd9dc7a3717e81688'
AND (
token = 'NfuQbY8anY8ZFD+zHnABv7HqVS73aqFr6SOrCqgcYno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)