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