UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '43UXSCYwwfD8Xc3ked72KnSBwnQ9tYBzTO3q606iIOA='
WHERE
key_id = 'd9e2961bb6243e1882889a7a121784916e53fa64d7cbc19fb79c6953eb4d6f61'
AND (
token = '43UXSCYwwfD8Xc3ked72KnSBwnQ9tYBzTO3q606iIOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)