UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0XI9LWfxwrHdx+I6QMG6na9MEukv7shZO7Ty4G7bg4='
WHERE
key_id = '9518378149b61c8842e2fae72e5fdd2ca0901edd4754cdd8b6eb3269c1104a04'
AND (
token = 'a0XI9LWfxwrHdx+I6QMG6na9MEukv7shZO7Ty4G7bg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)