UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sAeX6vOsSxqaitd47doJnhEsOyD8NqMvaGX9PaAuvIk='
WHERE
key_id = 'bab7a10df9e8d4823070a731a18a86102b014b70b0da552d7cb3b81a47a3b042'
AND (
token = 'sAeX6vOsSxqaitd47doJnhEsOyD8NqMvaGX9PaAuvIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)