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