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