UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xu4CjOZlhvcXEr4G+M6djmfikyd+fex8lIFgXO1JoX4='
WHERE
key_id = 'a7281f8971eb9c39ddfd95960f74c31d0d799378cbc11a7c1efa1bbe2b4d1eb0'
AND (
token = 'xu4CjOZlhvcXEr4G+M6djmfikyd+fex8lIFgXO1JoX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)