UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AJJAB097nwOZRHmrv0SkkWZLdCkWWKCQu4wie6c5yK8='
WHERE
key_id = '204ea42c7980e3215e151e601aa4ab3c7fcdb71fc8abaea08c7f94a0f55ea8cb'
AND (
token = 'AJJAB097nwOZRHmrv0SkkWZLdCkWWKCQu4wie6c5yK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)