UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hKGhG97/NHZTHv08PsK0zayyNG2e8TG0Mx1eCWVmSjA='
WHERE
key_id = 'a44aa41df61a5134a9659c77d1c7db8f52765ff322627d50defc29cb75a3699d'
AND (
token = 'hKGhG97/NHZTHv08PsK0zayyNG2e8TG0Mx1eCWVmSjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)