UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Waln3FfWtRNr1IfY+XS7YOM8zt8FzX6cpqOivmV2Lwk='
WHERE
key_id = 'aec8b19b80ba863d23dd382bb5349d42e481735d3001b78b4d878c0bbd5809f4'
AND (
token = 'Waln3FfWtRNr1IfY+XS7YOM8zt8FzX6cpqOivmV2Lwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)