UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TfQ3hhfy7Aam2+5Ny62y0onHK81XSOl0dUWOwK8YEdU='
WHERE
key_id = 'ca295e19e77de76d0f9b35a0b755108e01add5bd88beafdcf8d48259bf9bb1a3'
AND (
token = 'TfQ3hhfy7Aam2+5Ny62y0onHK81XSOl0dUWOwK8YEdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)