UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JKDt0pW6EToz5CVsFej5cOb+1k0JgDx4BxcVO9yD5lU='
WHERE
key_id = 'a9ef772384779fbeefb9cfdd80ccc2a9fedff3d6d05aac6d78c770244d373a14'
AND (
token = 'JKDt0pW6EToz5CVsFej5cOb+1k0JgDx4BxcVO9yD5lU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)