UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T+Xx1+sMN7hby4SP8ZOe8Ke2SsvvW5DKPu/bui8yWtM='
WHERE
key_id = '24b276101dc205a090f3949cf357b5e49e5c1ee37caf7c48c50d03846e9d87e7'
AND (
token = 'T+Xx1+sMN7hby4SP8ZOe8Ke2SsvvW5DKPu/bui8yWtM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)