UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P6AE+odKWr4TZ6KY09UW0Gs7sUKFUB4QgD6Din4aNEE='
WHERE
key_id = '33212043864ccd78c21fdde4b93cf66e1f39a1f9e1fdf1e69eb446eff6b5a9f4'
AND (
token = 'P6AE+odKWr4TZ6KY09UW0Gs7sUKFUB4QgD6Din4aNEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)