UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QcXW/e1OqwzhN1myXLLkER2ckCJjnwk3TIikWrOSrRA='
WHERE
key_id = 'a16d1a05ea79bfdd924e8c9866d2606a94ee8b8b5f389702cce07b8cc907fc61'
AND (
token = 'QcXW/e1OqwzhN1myXLLkER2ckCJjnwk3TIikWrOSrRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)