UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WDz3ODnmcjgn2DvbifWvN9V+8zojB3Sf/u6NSm88WDc='
WHERE
key_id = 'f5be678dff9f8ecf7a2e44fd618e7dcadb0206d345b4b943c90c3f9abd335d0b'
AND (
token = 'WDz3ODnmcjgn2DvbifWvN9V+8zojB3Sf/u6NSm88WDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)