UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mCgFkeKsYYRHZt9gIM/l0ZesMFw6LL9MZ5R3qz6LtwU='
WHERE
key_id = 'c80416ce085f7c3fdfb0a269660be9e55eebf1eac01f2965de432a6c58c2970c'
AND (
token = 'mCgFkeKsYYRHZt9gIM/l0ZesMFw6LL9MZ5R3qz6LtwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)