UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qfn1IxfruYCBT0mkc2jkkgOnt0YiT2FrUiJiqXkwgtk='
WHERE
key_id = '3a3c4d52111beabe9d3f4ffeef8f80eceac1c6d3ef2ac97e9a88d6b42800cc5b'
AND (
token = 'Qfn1IxfruYCBT0mkc2jkkgOnt0YiT2FrUiJiqXkwgtk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)