UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46ZTF66VJGebY17LshInUM/TbKI4n1Dlu1tRpbtjhzA='
WHERE
key_id = 'ccf8a5433526bf3d76aa3a23df28d9d2a6bbaae5d760224d5e96734199c9c5ee'
AND (
token = '46ZTF66VJGebY17LshInUM/TbKI4n1Dlu1tRpbtjhzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)