UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9CNsOmqWcbsgKNZhiBj9Pw6YUzjCMt5mKehTiH97Zs='
WHERE
key_id = '7be74d1e58ad42faabea9db31715fc93e903e4ae0351cb32938d44e525c11cb5'
AND (
token = 'D9CNsOmqWcbsgKNZhiBj9Pw6YUzjCMt5mKehTiH97Zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)