UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBbNSwGQmcDpfum9oLYhZezJHeSjdiKlif6Qyd8Cwbk='
WHERE
key_id = 'f8308a080d85df07584bc941344a59541dc656a815f22b67587d09bd3760fafa'
AND (
token = 'xBbNSwGQmcDpfum9oLYhZezJHeSjdiKlif6Qyd8Cwbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)