UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCh9DE+wRT6lCM6M+SPV3+7du9nMwax/v/fFscEQ/g8='
WHERE
key_id = 'b35761d4e02450e64d78fec176a600b7195f65974caa7b9d060a979ecf166a08'
AND (
token = 'QCh9DE+wRT6lCM6M+SPV3+7du9nMwax/v/fFscEQ/g8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)