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