UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7rK3PiES7XtNQqVpWu9G9m8fBSpC3YW1x4knwz1XiiM='
WHERE
key_id = 'd2aad471b256319355f184cc3331b16d6e47177b7b2aef3c687abe5ef298bd94'
AND (
token = '7rK3PiES7XtNQqVpWu9G9m8fBSpC3YW1x4knwz1XiiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)