UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCq2BatzznCQlt+EE8nC3ru1am9GIYOBlSCi/U3QPfA='
WHERE
key_id = '9acdf9c6dfd2ad0eb45e724d5af74ced28cf01e6c56015f84666a8c231919823'
AND (
token = 'hCq2BatzznCQlt+EE8nC3ru1am9GIYOBlSCi/U3QPfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)