UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9DafN+8X8fXZt+1mw3UV9avks2ecdZawNmrx3SJoqYA='
WHERE
key_id = '0ce42bedff4d8c7ef0b39e0cff4cf6e167a0f69e0ce549adaaa5daf4155177f7'
AND (
token = '9DafN+8X8fXZt+1mw3UV9avks2ecdZawNmrx3SJoqYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)