UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w6Gf8nib96Dav+jdJUOlHq3Imc01h2pqRDfhBxGU+mw='
WHERE
key_id = '5804242c0204bac5a4808faa99d9c30228de431c0f37d8707f0eaf8bf1ecdfda'
AND (
token = 'w6Gf8nib96Dav+jdJUOlHq3Imc01h2pqRDfhBxGU+mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)